package com.studentmanage.manage_class.dao;

import com.studentmanage.framework.domain.base.Learn;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface ClassMapper {
    @Select("<script>select distinct class.name as className, college.name as collegeName, specialize.name as specializeName " +
            "from student, class,college,specialize " +
            "where class.specializeid = specialize.id " +
            "and specialize.collegeid = college.id " +
            "and class.id = #{id}</script>")
    public Learn findLearn(String id);
}
